﻿USE [TicketAppDBNew]
GO
/****** Object:  Table [dbo].[TicketTemplates]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[TicketTemplates] ON
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (1, N'TicketTemplate-1 HTML', N'TicketTemplate-1')
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (3, N'TicketTemplate-2-Desc', N'TicketTemplate-2')
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (4, N'TicketTemplate-1 HTML-Copy', N'TicketTemplate-1-Copy')
SET IDENTITY_INSERT [dbo].[TicketTemplates] OFF
/****** Object:  Table [dbo].[Roles]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Roles] ON
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (1, N'Administrator')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (2, N'Client')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (3, N'Agent')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (4, N'Website User')
SET IDENTITY_INSERT [dbo].[Roles] OFF
/****** Object:  Table [dbo].[Events]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Events] ON
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status], [ImageUrl]) VALUES (2, N'Event1', CAST(0x00009F5A01102FB0 AS DateTime), CAST(0x00009F5A01107600 AS DateTime), N'IST', N'Desc', 0, NULL)
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status], [ImageUrl]) VALUES (3, N'Event2', CAST(0x00009F5A01126230 AS DateTime), CAST(0x00009F5A0112A880 AS DateTime), N'IST', N'Event2-Desc', 1, NULL)
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status], [ImageUrl]) VALUES (4, N'Event New', CAST(0x00009F66010F5CC0 AS DateTime), CAST(0x00009F5A010F5CC0 AS DateTime), N'IST', N'Desc', 1, NULL)
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status], [ImageUrl]) VALUES (5, N'Event3', CAST(0x00009F6E00000000 AS DateTime), CAST(0x00009F5C00000000 AS DateTime), N'IST', N'Event3-Desc', 1, NULL)
SET IDENTITY_INSERT [dbo].[Events] OFF
/****** Object:  Table [dbo].[Contacts]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Contacts] ON
INSERT [dbo].[Contacts] ([Id], [Phone], [Email], [Name]) VALUES (1, N'Venue1-Phone', N'Venue1@mail.com', N'Venue1-Contact')
INSERT [dbo].[Contacts] ([Id], [Phone], [Email], [Name]) VALUES (2, N'Venue3-Phone', N'Venue3@mail.com', N'Venue3-Contact')
INSERT [dbo].[Contacts] ([Id], [Phone], [Email], [Name]) VALUES (3, N'Venue2-Phone', N'Venue2@mail.com', N'Venue2-Contact')
SET IDENTITY_INSERT [dbo].[Contacts] OFF
/****** Object:  Table [dbo].[Cities]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Cities] ON
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (1, N'Abohar', N'Punjab', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (2, N'Achalpur', N'Maharashtra', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (3, N'Ad', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (4, N'Adilabad', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (5, N'Adipur', N'Gujarat', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (6, N'Adoni', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (7, N'Adoor', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (8, N'Adra, Purulia', N'West Bengal', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (9, N'Agartala*', N'Tripura', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (10, N'Agra', N'Uttar Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (11, N'Ahmedabad', N'Gujarat', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (12, N'Ahmedgarh', N'Punjab', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (13, N'Ahmednagar', N'Maharashtra', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (14, N'Aizawl*', N'Mizoram', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (15, N'Ajmer', N'Rajasthan', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (16, N'Akaltara', N'Chhattisgarh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (17, N'Akola', N'Maharashtra', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (18, N'Alappuzha', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (19, N'Aligarh', N'Uttar Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (20, N'Alipurduar', N'West Bengal', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (21, N'Allahabad', N'Uttar Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (22, N'Almora', N'Uttaranchal', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (23, N'Alwar', N'Rajasthan', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (24, N'Amadalavalasa', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (25, N'Amalapuram', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (26, N'Amarpur', N'Bihar', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (27, N'Ambikapur', N'Chhattisgarh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (28, N'Ambala', N'Haryana', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (29, N'Ambala', N'Haryana', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (30, N'Amli', N'Dadra & Nagar Haveli', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (31, N'Amravati', N'Maharashtra', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (32, N'Amreli', N'Gujarat', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (33, N'Amritsar', N'Punjab', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (34, N'Amroha', N'Uttar Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (35, N'Anakapalle', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (36, N'Anand', N'Gujarat', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (37, N'Anandapur', N'Orissa', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (38, N'Anantapur', N'Andhra Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (39, N'Anantnag', N'Jammu and Kashmir', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (40, N'Ancharakandy', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (41, N'Ankleshwar', N'Gujarat', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (42, N'Anugul', N'Orissa', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (43, N'Arakkonam', N'Tamil Nadu', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (44, N'Araria', N'Bihar', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (45, N'Arambagh', N'West Bengal', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (46, N'Arasikere', N'Karnataka', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (47, N'Arcot', N'Tamil Nadu', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (48, N'Areraj', N'Bihar', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (49, N'Arrah', N'Bihar', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (50, N'Aroor', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (51, N'Aruppukkottai', N'Tamil Nadu', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (52, N'Asansol', N'West Bengal', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (53, N'Ashok Nagar', N'Madhya Pradesh', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (54, N'Ashtamichira', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (55, N'Asika', N'Orissa', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (56, N'Assandh', N'Haryana', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (57, N'Attingal', N'Kerala', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (58, N'Aurangabad', N'Bihar', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (59, N'Aurangabad', N'Maharashtra', N'India')
INSERT [dbo].[Cities] ([Id], [CityName], [State], [Country]) VALUES (60, N'Azamgarh', N'Uttar Pradesh', N'India')
SET IDENTITY_INSERT [dbo].[Cities] OFF
/****** Object:  Table [dbo].[PaymentModes]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[PaymentModes] ON
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (1, N'Cash')
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (2, N'Credir Card')
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (3, N'Gift Coupon')
SET IDENTITY_INSERT [dbo].[PaymentModes] OFF
/****** Object:  Table [dbo].[Addresses]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Addresses] ON
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (1, N'Line1-1', N'Line2-1', 1, N'111111')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (2, N'Client-Line1', N'Client-Line2', 3, N'123')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (8, N'Line1-Customer1', N'line2-Customer1', 1, N'123')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (14, N'Line1-Venue1', N'Line2-Venue1', 1, N'798')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (16, N'Line1-Vemue2', N'Line2-Venue2', 1, N'789')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (17, N'Client2-Line1', N'Client2-Line2', 1, N'69')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (18, N'Client3-Line1', N'Client3-Line2', 40, N'6790')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (20, N'Line1-Agent1', N'Line2-Agent1', 1, N'798')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (21, N'Line1-Agent2', N'Line2-Agent2', 1, N'90')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (23, N'Line1-Agent3', N'Line2-Agent3', 1, N'4343')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (25, N'Venue3-Line1', N'Venue3-Line2', 1, N'690')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (26, N'Customer2-Line1', N'Customer2-Line2', 1, N'69')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (27, N'hjilkj', N'jl;j.m', 1, N'm;km')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City_Id], [PostalCode]) VALUES (28, N'Agent1-New', N'Agent1-New', 1, N'Agent1-New')
SET IDENTITY_INSERT [dbo].[Addresses] OFF
/****** Object:  Table [dbo].[Venues]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Venues] ON
INSERT [dbo].[Venues] ([Id], [Description], [Name], [Address_Id], [ImageUrl], [Contacts_Id]) VALUES (1, N'Dewcription-Venue1', N'Venue1', 14, NULL, 1)
INSERT [dbo].[Venues] ([Id], [Description], [Name], [Address_Id], [ImageUrl], [Contacts_Id]) VALUES (3, N'Venue2-Desc', N'Venue-2', 16, NULL, 3)
INSERT [dbo].[Venues] ([Id], [Description], [Name], [Address_Id], [ImageUrl], [Contacts_Id]) VALUES (5, N'Venue3-Desc', N'Venue3', 25, NULL, 2)
SET IDENTITY_INSERT [dbo].[Venues] OFF
/****** Object:  Table [dbo].[Users]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (2, N'Client1', N'Password@1', N'Client1@email.com', N'Client-123', 1, 2, 2, 2)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (8, N'Customer1', N'Password@1', N'Customer1@mail.com', N'123', 1, 4, 8, 4)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (10, N'Super1', N'Password@1', N'super@mail.com', N'121', 1, 1, 2, 1)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (16, N'Client2', N'Password@1', N'Client2@Mail,com', N'r765', 1, 2, 17, 2)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (17, N'Client3', N'Password@1', N'Client3@mail.com', N't689', 1, 2, 18, 2)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (19, N'Agent1', N'Password@1', N'Agent1@mail.com', N'57', 1, 3, 20, 3)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (20, N'Agent2', N'Password@1', N'Agent2@mail.com', N'89766786655', 1, 3, 21, 3)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (22, N'Agent3', N'Password@1', N'Agent3@mail.com', N'70', 1, 3, 23, 3)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (23, N'Customer2', N'Password@1', N'Customer2@mail.com', N'76098p', 1, 4, 26, 4)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (24, N'wfwefew', N'nbhiolk', N'nln', N'790', 1, 3, 27, 3)
INSERT [dbo].[Users] ([Id], [UserName], [Password], [Email], [Phone], [Status], [UserType], [Address_Id], [Role_Id]) VALUES (25, N'Agent1-New', N'Agent1-New', N'Agent1-New', N'Agent1-New', 1, 3, 28, 3)
SET IDENTITY_INSERT [dbo].[Users] OFF
/****** Object:  Table [dbo].[EventVenues]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[EventVenues] ON
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id], [ShowName], [ShowDateTime], [Description], [ImageUrl], [Template_Id]) VALUES (1, 2, 1, N'Show1 For Event1 and Venue1', CAST(0x00009F5A0112A880 AS DateTime), N'Show1-Description', N'Show1-Image', 1)
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id], [ShowName], [ShowDateTime], [Description], [ImageUrl], [Template_Id]) VALUES (3, 3, 3, N'Show2', CAST(0x00009FD600000000 AS DateTime), N'Show2-Desc', N'image-Show2', 3)
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id], [ShowName], [ShowDateTime], [Description], [ImageUrl], [Template_Id]) VALUES (4, 5, 5, N'Show1-Event3-Venue3', CAST(0x00009F5C00C5C100 AS DateTime), N'Show1-Event3-Venue3-Desc', NULL, 4)
SET IDENTITY_INSERT [dbo].[EventVenues] OFF
/****** Object:  Table [dbo].[EventsUsers]    Script Date: 09/15/2011 00:02:53 ******/
/****** Object:  Table [dbo].[AgentBranches]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[AgentBranches] ON
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [Agent_Id], [Name]) VALUES (2, 20, 19, N'Agent1')
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [Agent_Id], [Name]) VALUES (3, 21, 20, N'Agent2')
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [Agent_Id], [Name]) VALUES (5, 23, 22, N'Agent3')
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [Agent_Id], [Name]) VALUES (6, 27, 24, N'wfwefew')
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [Agent_Id], [Name]) VALUES (7, 28, 25, N'Agent1-New')
SET IDENTITY_INSERT [dbo].[AgentBranches] OFF
/****** Object:  Table [dbo].[Payments]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Payments] ON
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (1, 560.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (2, 10000.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (3, 5000.0000, 1, 3, 23)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (4, 8000.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (5, 1000.0000, 1, 2, 23)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (6, 1000.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (7, 500.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (8, 500.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (9, 700.0000, 1, 1, 8)
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [Customer_Id]) VALUES (10, 1000.0000, 1, 2, 23)
SET IDENTITY_INSERT [dbo].[Payments] OFF
/****** Object:  Table [dbo].[TicketTypes]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[TicketTypes] ON
INSERT [dbo].[TicketTypes] ([Id], [Class], [Price], [TotalSeats], [AllottedSeats], [Description], [EventVenue_Id]) VALUES (1, N'Show1-Class1', 560.0000, 100, 20, N'Show1-Class1-Desc', 1)
INSERT [dbo].[TicketTypes] ([Id], [Class], [Price], [TotalSeats], [AllottedSeats], [Description], [EventVenue_Id]) VALUES (2, N'Show1-Class2', 500.0000, 200, 145, N'Show1-Class2-Desc', 1)
INSERT [dbo].[TicketTypes] ([Id], [Class], [Price], [TotalSeats], [AllottedSeats], [Description], [EventVenue_Id]) VALUES (4, N'Show2-Class1', 800.0000, 100, 60, N'Show2-Class1-Desc', 3)
INSERT [dbo].[TicketTypes] ([Id], [Class], [Price], [TotalSeats], [AllottedSeats], [Description], [EventVenue_Id]) VALUES (5, N'Class1-Show1-Event3-Venue3', 100.0000, 50, 50, N'Class1-Show1-Event3-Venue3-Desc', 4)
SET IDENTITY_INSERT [dbo].[TicketTypes] OFF
/****** Object:  Table [dbo].[Tickets]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[Tickets] ON
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (11, NULL, CAST(0x00009FD600000000 AS DateTime), N'b34546ef-5ced-4cb4-903d-d781858873e8', NULL, NULL, 2, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (12, NULL, CAST(0x00009FD600000000 AS DateTime), N'9351be1c-cc1d-4f03-8b23-0ef428cf5525', NULL, NULL, 2, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (13, NULL, CAST(0x00009FD600000000 AS DateTime), N'e61ff57f-39de-4bd5-a570-5a6a4ca9430b', NULL, NULL, 2, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (14, NULL, CAST(0x00009FD600000000 AS DateTime), N'b2153a99-2a35-4b5c-99cf-e4923ca80f9e', NULL, NULL, 2, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (15, NULL, CAST(0x00009FD600000000 AS DateTime), N'9ec9ce34-214f-4df8-b37a-7c5d0d4bb4ed', NULL, NULL, 2, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (20, NULL, CAST(0x00009FD600000000 AS DateTime), N'7fdb67bd-a0f6-44b4-ad79-30437babefaf', NULL, 1, 8, 1, 2)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (21, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'ac276500-2007-4624-8e8f-98858f77cfdd', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (22, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'ac0cce79-f37f-4dc8-bbd1-b2c912edee91', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (23, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'9e30eb34-b3e1-4329-8e56-ae67f5e547f3', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (24, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'28e609d6-f25c-4d0b-88af-56ad416db771', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (25, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'bf3adc82-a15d-4efe-ad80-1c2781f534aa', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (26, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'ef1debf0-5541-47df-9883-59edffdc3009', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (27, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'40389a43-ef5f-43ea-9b41-2573f1bcc6ba', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (28, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'ab251337-436c-4b71-a9b4-65a02935d244', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (29, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'38e54249-dec0-4e9e-9ee6-bba1a6d54c3b', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (30, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'1380acf7-1613-4880-901e-cae0b8bdfd35', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (31, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'f7371257-ead8-40ec-8bc8-4e8a9de3a74c', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (32, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'33b7a9bd-7474-42f5-ae26-5bbce6bfc8f6', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (33, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'2d828f08-1371-452e-a4c6-c62e60162a27', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (34, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'30a8b5e5-0832-488b-b1b2-8e6087b5a9db', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (35, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'7950293b-435a-4b2f-845b-bfec7bef16af', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (36, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'8792aaae-625a-4494-95b1-8754a5661930', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (37, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'1c96e178-05db-449d-8264-70c41581d614', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (38, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'61d41a10-ed5a-469b-9e55-94c5bcd83104', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (39, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'42522cb0-4578-490d-a426-cb0d4242326d', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (40, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'e101561d-7c1d-410b-ae23-9e737827d5bf', NULL, 2, 8, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (41, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'b87885f8-9fb1-4e03-b660-9e621a58ab47', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (42, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'690ab46f-d4ef-4536-b80e-a14ae3169424', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (43, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'b1b3b155-61a1-46b5-b506-7f4aafe5c5eb', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (44, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'd1c98a07-b5fa-4945-8054-833e3d51d237', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (45, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'6ffa0197-3452-4a3e-89db-2c3b1d21119e', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (46, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'53463149-f798-477a-afd9-b90a110f2aff', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (47, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'22c99758-8d13-4f86-ab2e-260f84ef446a', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (48, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'ac1b8f62-7812-43a6-ac0e-3e82871049f0', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (49, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'efe5eda2-4634-4e87-a896-a5887d6e60bb', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (50, NULL, CAST(0x00009F5A0112A880 AS DateTime), N'8af4ccaa-dd8b-4fcc-872e-916b5bf8bcd1', NULL, 3, 23, 2, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (51, NULL, CAST(0x00009FD600000000 AS DateTime), N'217ef1fe-4c30-4b87-b21f-a0e85d604646', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (52, NULL, CAST(0x00009FD600000000 AS DateTime), N'47ff123f-0423-4b16-85df-bdde1849c1f9', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (53, NULL, CAST(0x00009FD600000000 AS DateTime), N'471ea6f2-a38c-4a0d-b0f2-d0ffab093414', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (54, NULL, CAST(0x00009FD600000000 AS DateTime), N'8c952b0e-0b38-46f3-8a37-6f75162b9158', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (55, NULL, CAST(0x00009FD600000000 AS DateTime), N'05fee831-0063-42db-8513-6f77021addf8', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (56, NULL, CAST(0x00009FD600000000 AS DateTime), N'bc61cdb9-ed89-47f7-b048-3ce3f1eccaa5', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (57, NULL, CAST(0x00009FD600000000 AS DateTime), N'0d17cf37-2e27-405c-9ca9-c430f2482e90', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (58, NULL, CAST(0x00009FD600000000 AS DateTime), N'57d843f6-61de-41eb-ba92-92fd6658a145', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (59, NULL, CAST(0x00009FD600000000 AS DateTime), N'c2bb1112-5652-4972-8362-0614197dd6d4', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (60, NULL, CAST(0x00009FD600000000 AS DateTime), N'65a98b47-902b-4f2a-b3ef-80db05e13350', NULL, 4, 8, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (61, NULL, CAST(0x00009FD600000000 AS DateTime), N'eff6cb6e-1099-4965-8268-e7fedcc4ce8b', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (62, NULL, CAST(0x00009FD600000000 AS DateTime), N'061a6094-305e-44f4-8877-4d426f38f260', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (63, NULL, CAST(0x00009FD600000000 AS DateTime), N'bf462d72-c206-4b76-b1a8-c8a430f671c1', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (64, NULL, CAST(0x00009FD600000000 AS DateTime), N'a7c31bcb-eee1-44a3-b636-5f6fc12a5b76', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (65, NULL, CAST(0x00009FD600000000 AS DateTime), N'a7c454cd-ed40-4b87-a1ca-b951e5c43a5e', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (66, NULL, CAST(0x00009FD600000000 AS DateTime), N'164f0bc3-154e-4eb1-a96a-1bd8dc5964bf', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (67, NULL, CAST(0x00009FD600000000 AS DateTime), N'02fdf605-83bf-480a-8a3a-1ef55214720a', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (68, NULL, CAST(0x00009FD600000000 AS DateTime), N'85c2df21-156b-45b0-bcd5-68ac6b85c426', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (69, NULL, CAST(0x00009FD600000000 AS DateTime), N'4b6faa30-7125-48a2-9f5d-3ce9b66f5a36', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (70, NULL, CAST(0x00009FD600000000 AS DateTime), N'413de54e-e833-41e3-8af9-a7cea8964443', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (71, NULL, CAST(0x00009FD600000000 AS DateTime), N'41ea18f8-75e5-4841-b892-de05e4272709', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (72, NULL, CAST(0x00009FD600000000 AS DateTime), N'06144c4a-93ac-4c6c-be66-a2b1cf245159', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (73, NULL, CAST(0x00009FD600000000 AS DateTime), N'd16eb937-3b30-4f1a-b8dc-6c1bc913e61f', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (74, NULL, CAST(0x00009FD600000000 AS DateTime), N'9d701108-255b-4143-a316-83cc6c79ce85', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (75, NULL, CAST(0x00009FD600000000 AS DateTime), N'fc9d05ca-e381-495e-98f9-e1323869ad3c', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (76, NULL, CAST(0x00009FD600000000 AS DateTime), N'8485ff60-ed0e-4f28-886d-f22a3a8e18ea', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (77, NULL, CAST(0x00009FD600000000 AS DateTime), N'f8b3559b-c372-498d-9325-ea789d5e97d3', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (78, NULL, CAST(0x00009FD600000000 AS DateTime), N'd24b708b-4c17-487b-b6f3-d15f0bc7ddc4', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (79, NULL, CAST(0x00009FD600000000 AS DateTime), N'db969352-727a-4699-ac0c-e8ef7b93b626', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (80, NULL, CAST(0x00009FD600000000 AS DateTime), N'e65e37f8-4375-4d98-96f4-e05cd96354d7', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (81, NULL, CAST(0x00009FD600000000 AS DateTime), N'01f3db37-fe17-40e5-b912-d8b36b50e832', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (82, NULL, CAST(0x00009FD600000000 AS DateTime), N'314a304e-ee24-4c92-9d98-22ddaf0788b1', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (83, NULL, CAST(0x00009FD600000000 AS DateTime), N'9eae6266-9ff4-4187-b5b6-8cd32b1a73a6', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (84, NULL, CAST(0x00009FD600000000 AS DateTime), N'329e75a6-43fb-4b7a-b2b3-22c43c35ec86', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (85, NULL, CAST(0x00009FD600000000 AS DateTime), N'0a606972-d4bb-4da4-8f13-06dbc52d0f22', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (86, NULL, CAST(0x00009FD600000000 AS DateTime), N'8536eae4-83de-46f1-9bca-dfc4cb98bd82', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (87, NULL, CAST(0x00009FD600000000 AS DateTime), N'ffbcf3dc-fdb6-4ff4-a26d-2a744dea79ab', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (88, NULL, CAST(0x00009FD600000000 AS DateTime), N'eef41fa6-4cd7-4ff9-8fd1-11407227efad', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (89, NULL, CAST(0x00009FD600000000 AS DateTime), N'0b564226-e467-4352-9c9f-c9a7f0c1157a', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (90, NULL, CAST(0x00009FD600000000 AS DateTime), N'5bf43d5a-6c24-4614-995f-ddc6e48e10f1', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (91, NULL, CAST(0x00009FD600000000 AS DateTime), N'0bbdde9e-1392-4086-bf29-5ea3135b256b', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (92, NULL, CAST(0x00009FD600000000 AS DateTime), N'57d4965f-fa64-4907-bb59-513c26f77b2a', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (93, NULL, CAST(0x00009FD600000000 AS DateTime), N'4ad72d97-c478-48ce-afc9-a6ebbb2744f1', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (94, NULL, CAST(0x00009FD600000000 AS DateTime), N'f096aedc-d409-4ae8-ac59-411317e862ae', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (95, NULL, CAST(0x00009FD600000000 AS DateTime), N'c4177a97-2077-4481-97ca-f3a05b3cea33', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (96, NULL, CAST(0x00009FD600000000 AS DateTime), N'04504823-94f4-4bde-9bc7-280f023902f6', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (97, NULL, CAST(0x00009FD600000000 AS DateTime), N'ae7955c4-8007-4600-8723-80252ebb72f5', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (98, NULL, CAST(0x00009FD600000000 AS DateTime), N'f864c78a-6d1f-4373-a0aa-54bbdd4fb02e', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (99, NULL, CAST(0x00009FD600000000 AS DateTime), N'7c40d670-f0a7-4d9b-923c-921f1dccbb27', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (100, NULL, CAST(0x00009FD600000000 AS DateTime), N'da25f0ad-8bdb-4a00-8c19-0fcbde6fd605', NULL, NULL, NULL, 4, 3)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (101, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'25c44b07-3a78-4258-a645-eaabe963c0a5', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (102, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'e9ac3f1c-98c7-4151-94ac-77926ea3fc82', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (103, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'cd798c28-8d97-4928-9918-fd728410959c', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (104, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'f237ba79-4103-4192-afd3-522f57558e6f', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (105, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'53f58057-2c91-4bed-9fc5-01c4c6c74e06', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (106, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'5daa7561-36b7-4c95-9615-bf02a00f6aeb', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (107, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'57fa8526-a931-453d-a22c-97e9c1681ea4', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (108, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'65865c7f-5526-428f-9e44-63793a79f8fb', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (109, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'9087d445-ba72-415c-9d3d-647b23c39590', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (110, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'a37857ec-1629-4b86-bed0-5ffee1360bc7', NULL, 5, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (111, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'0f8ec991-93c5-4462-87a7-e1e13593996e', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (112, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'58101f4d-33b3-457e-a61c-cb741aabcb95', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (113, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'184f338b-5b09-4374-868e-328b402a1e93', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (114, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'fe4433d5-f788-496b-b93e-502c79afac33', NULL, 6, 8, 5, 5)
GO
print 'Processed 100 total records'
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (115, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'f7d665ae-7ee8-48e7-a75b-aa00ac698d00', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (116, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'8783c937-f105-4328-b894-6aa341f243a8', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (117, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'fd853f55-9a7f-4b2f-8dd6-80ffec235167', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (118, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'22a9983d-0330-439d-9f9b-7f0df13f29e4', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (119, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'c6aa0981-13e2-4f86-a2bc-e2134279b814', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (120, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'0a04b393-18db-441d-8e6a-99ef5b16a7d2', NULL, 6, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (121, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'80eb3b22-f149-4676-b8c6-709c744d71b1', NULL, 7, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (122, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'ebc6a7e3-0c39-4cfa-ba41-d1494d880b5b', NULL, 7, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (123, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'aab93714-490e-4780-a3c9-0c75ff41c03b', NULL, 7, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (124, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'793aa6f7-90ca-42f5-9fbe-60ce704c75c8', NULL, 7, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (125, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'0dd4e910-f217-4959-af93-f278c1832f59', NULL, 7, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (126, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'c7aba69f-97d7-491a-ac47-67153fb1df07', NULL, 8, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (127, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'd3d265cf-3f58-4c99-8150-1e5a9bc0cd71', NULL, 8, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (128, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'df21c8f4-7113-43e5-8ea3-c1e1d68ed55d', NULL, 8, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (129, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'a664a871-1af0-4d1f-8427-f8a65d593654', NULL, 8, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (130, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'ae9a3f34-8576-4552-948c-1cba01839506', NULL, 8, 8, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (161, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'2a3dd142-0be0-41fe-906a-2aed5b17e5f2', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (162, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'aab58bff-8f22-4761-994f-6517cf5da295', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (163, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'bae70889-f200-4d5a-96f2-6ae2ff8142b5', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (164, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'57f4aedf-7f9a-429d-b340-bc28071f6b02', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (165, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'fe8ef41f-04a8-4c55-b1cf-d54249623fd0', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (166, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'92c20b10-539d-49e0-b641-0f63786998d8', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (167, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'6c687486-8fe8-405e-92dd-13dc28d7ed94', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (168, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'fc6db009-79c9-4bac-a57f-c81b96877a90', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (169, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'646fd0e8-670c-4ac8-948d-775ac81acae0', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (170, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'e3fea6b3-0f84-413f-9d54-c2f15c847f0b', NULL, 10, 23, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (171, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'b9193649-922f-4387-aa9e-d94f0417d8d7', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (172, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'dd4a91e7-cec5-46a0-b84d-1ef14d33eafe', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (173, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'71e343bb-b369-4b8c-8ad2-4b732ada85da', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (174, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'b7affaae-9de2-4698-be27-2771ea0504f4', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (175, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'a24caaf2-4d40-4029-af15-42df066e737c', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (176, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'f019631a-4505-49d3-b453-2e72cbd7cfcf', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (177, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'1f655423-e1ae-4766-9862-c9deda9cfe61', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (178, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'c92782bb-4230-4639-a41d-63f0457db8ba', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (179, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'fc98bfdd-b042-4f0e-874b-8e186b31cbdd', NULL, NULL, NULL, 5, 5)
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [Payment_Id], [Customer_Id], [TicketType_Id], [AgentBranch_Id]) VALUES (180, NULL, CAST(0x00009F5C00C5C100 AS DateTime), N'91f95d1c-8391-428f-aa3d-9a0431dbf4f7', NULL, NULL, NULL, 5, 5)
SET IDENTITY_INSERT [dbo].[Tickets] OFF
/****** Object:  Table [dbo].[TicketQuotas]    Script Date: 09/15/2011 00:02:53 ******/
SET IDENTITY_INSERT [dbo].[TicketQuotas] ON
INSERT [dbo].[TicketQuotas] ([Id], [QuotaQuantity], [TicketType_Id], [AgentBranch_Id]) VALUES (7, 6, 1, 2)
INSERT [dbo].[TicketQuotas] ([Id], [QuotaQuantity], [TicketType_Id], [AgentBranch_Id]) VALUES (8, 30, 2, 3)
INSERT [dbo].[TicketQuotas] ([Id], [QuotaQuantity], [TicketType_Id], [AgentBranch_Id]) VALUES (9, 50, 4, 3)
INSERT [dbo].[TicketQuotas] ([Id], [QuotaQuantity], [TicketType_Id], [AgentBranch_Id]) VALUES (10, 50, 5, 5)
SET IDENTITY_INSERT [dbo].[TicketQuotas] OFF
